[dbo].[BAECartEventFunctionGetForUserByFunctionCode]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAECartEventFunctionGetForUserByFunctionCode

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@CartEventId	int	4
@FunctionCode	varchar(32)	32

SQL Script

create procedure [dbo].[BAECartEventFunctionGetForUserByFunctionCode] @CartEventId int,
     @FunctionCode varchar(32) as
SELECT cef.CartEventFunctionID
    FROM CartEventFunction cef
    INNER JOIN CartEvent ce on ce.CartEventID = cef.CartEventID
    WHERE ce.CartEventID = @CartEventId
        AND cef.FunctionCode = @FunctionCode

GO

Uses

[dbo].[CartEvent]
[dbo].[CartEventFunction]
dbo